{venue}

Ucase

{venue_short}

Ucase, If EntryLabel <> '' then First 14 Chars

{venue_address}

{ticket_title}

{ticket_title_short}

First 12 Chars

{performance_date}

Format: dd/mm/yy

{performance_day}

Format: ddd (i.e. Mon,Tue,Wed, etc.)

{performance_date_long}

Format: d mmm yyyy

{performance_date_dd}

Format: dd - i.e. day in month

{performance_date_mm}

Format: mm - i.e. month number

{performance_date_month}

Format: mmm i.e. month name Jan, Feb, ...

{performance_date_yy}

Format: yy - i.e. two-digit year

{performance_date_yyyy}

Format: yyyy - i.e. four-digit year

{performance_time}

Format: h:nn am/pm

{book_type}

{book_type_short}

First word

{seat_type}

{price}

{section_description}

{entry_label}

{area}

Blank if tblProd.GenAdmit = 'Y'

{area_description}

Blank if tblProd.GenAdmit = 'Y'

{row}

Blank if tblProd.GenAdmit = 'Y'

{seat}

Blank if tblProd.GenAdmit = 'Y'

{force_area}

Ignores value of tblProd.GenAdmit = 'Y'

{force_area_description}

Ignores value of tblProd.GenAdmit = 'Y'

{force_row}

Ignores value of tblProd.GenAdmit = 'Y'

{force_seat}

Ignores value of tblProd.GenAdmit = 'Y'

{print_serial}

Count of the number of seats printed for this performance - reprinted tickets will have a higher serial than the original ticket. The highest serial number is likely to be greater than the number of seats sold.

{venue_serial}

Count of the number of seats with area/row/seat ID <= this seat - reprinted tickets will have the same serial as the original ticket, but changes to the performance seating plan will make previously printed serials invalid. This serial depends on the seat coordinates, so the first one is not guaranteed to be 1 and they are not guaranteed to be consecutive (but they probably will be for GA productions)

{wheelchair}

If = 'Y' then 'WH', otherwise blank

{reprint}

if > 0 then 'REPRINT', otherwise blank

{sale_id}

{alpha_code}

The alphanumeric code for the ticket for the barcode;wrap it in *s (i.e. use *{alpha_code}*) to ensure it creates a valid Code39 code; using FGL, then then need to make sure that the line/code is in the 'barcode' font

{num_code}

The numeric code for the ticket (i.e. digits and #) for the barcode

{user}

Currently logged in user

{prod_id}

{payment}

If = 'Y' then 'PAID', otherwise '****'

{surname}

{first_name}

{phone}

if blank, same as 'business' below

{business}

{uid}

{print_time}

{merchant_gst_number}

{merchant_abn_number}

{product_name}

Ucase

{valid_for}

Expiry Date, or Production Name if Expiry Date is blank

{value}

NumSeats or VoucherValue ; 'n seats' or '$d.cc'

{voucher_id}

{expiry_date}

Format: dd/mm/yy

{expiry_date_long}

Format: d mmm yyyy

{production}

{surname}

{first_name}

{phone}

{business}

{uid}

{payment}

If = 'Y' then 'PAID', otherwise '****'

{user}

Currently logged in Operator

{prod_id}

{sale_id}

{reprint}

if > 0 then 'REPRINT', otherwise blank

{print_time}

{merchant_gst_number}

{merchant_abn_number}

{name}

{line1_or_blank}

first line of preferred address

{line2_or_blank}

second line of preferred address

{line3_or_blank}

third line of preferred address

{city_or_blank}

fourth line of preferred address or WebMailCity, depending on user choice

{state_or_blank}

{line1_not_blank}

first line of preferred address or if blank, the line below it

{line2_not_blank}

second line of preferred address or if blank, the line below it

{line3_not_blank}

third line of preferred address or if blank, the line below it

{line4_not_blank}

fourth line of preferred address or if blank, the line below it

{line5_not_blank}

fifth line of preferred address or blank (despite the name). The ..._not_blank series of fields should be used together, and allows the possibility of suppressing blank lines on address labels, because a blank line causes all subsequent lines to be moved up one

{postcode}

If = 0 then ''

{uid}

Patron UID

{merchant_name}

CompanyName from tblSettings

{merchant_id}

Where ProprtyName = 'cc_merchant_id'

{merchant_address1}

from tblSettings

{merchant_address2}

from tblSettings

{merchant_phone}

from tblSettings

{merchant_gst_number}

from tblSettings Tax Number

{merchant_abn_number}

from tblSettings Tax Number

{payment_type}

{card_number}

formatted nnnn…nnnn

{card_number_full}

in its full glory, with no digits obscured

{card_name}

the name on the credit card

{card_expiry}

stored as yymm but displayed as mm/yy

{amount}

{transaction_seq}

tblCardTransaction, SequenceNumber

{transaction_date}

Format: dd/mm/yy

{transaction_date_day}

Format: ddd (ie. Mon,Tue,Wed, etc.)

{transaction_date_long}

Format: d mmm yyyy

{transaction_date_time}

Format: h:nn am/pm

{sale_id}

{user}

Currently logged in Operator

{print_time}

Format:yyyy-mm-dd hh:mi:ss

{surname}

{first_name}

{patron_phone}

{uid}

{ticket_title_1}

The first production (alphabetically) on the sale, if any

{ticket_title_2}

The second production (alphabetically) on the sale, if any

{product_1}

The first product (alphabetically) on the sale, if any

{product_2}

The second product (alphabetically) on the sale, if any

{sale_id}

{alpha_code}

{num_code}

{production}

{performance}

{auth_code}

{total}

{date}

{mailout}

Mailout if they selected this option during the booking, otherwise Collect (for all sales including non-web sales)

{sale_id}

{alpha_code}

The alphanumeric code for the sale for the barcode

{num_code}

The numeric code for the sale (i.e. digits and #) for the barcode

{venue}

{ticket_title}

{ticket_title_short}

First 12 Chars

{performance_date}

Format: dd/mm/yy

{performance_day}

Format: ddd (I.e. Mon,Tue,Wed, etc.)

{performance_date_long}

Format: d mmm yyyy

{performance_time}

Format: h:nn am/pm

{name}

{surname}

{first_name}

{address1}

{address2}

{address3}

{city}

{state}

{postcode}

{uid}

{contact_name}

blank if the sale has no contact patron set

{contact_surname}

blank if the sale has no contact patron set

{contact_first_name}

blank if the sale has no contact patron set

{paid_total}

sum for this sale

{seat_total}

sum for this sale

{product_total}

sum for this sale

{total_due}

seat_total + product_total

{still_to_pay}

total_due - paid_total

{sale_seat_count}

sum for this sale

{performance_seat_count}

sum for this performance

{area_1}

name of first area

{area_1_seat_range}

contiguous seat ranges

{area_2}

name of second area

{area_2_seat_range}

contiguous seat ranges

{area_3}

name of third area

{area_3_seat_range}

contiguous seat ranges

{more_areas}

blank if there are 3 or less areas, otherwise the text: 'plus n more areas'

{more_seats}

{mailout}

Mailout if they selected this option during the booking, otherwise Collect (for all sales including non-web sales)